[dbo].[BAEBillingBillingCategories]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEBillingBillingCategories

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@UserID	varchar(10)	10
@MemberType	varchar(5)	5

/*
    This procedure returns all of the billing categories available for the user to select.

    NOTE:

    While this procedure may return an empty resultset, you MUST have the CODE and DESCRIPTION columns.
    The billing categories come from the General Lookup table in iMIS.
*/
CREATE PROCEDURE [dbo].[BAEBillingBillingCategories]
    @UserID            AS    varchar(10),
    @MemberType     AS    varchar(5)
AS
    SELECT CODE, DESCRIPTION FROM Gen_Tables WHERE TABLE_NAME = 'CATEGORY';

set ANSI_NULLS OFF
set QUOTED_IDENTIFIER OFF

GO